package com.cebbank.yyi.springbootapp.dao;

import com.cebbank.yyi.springbootapp.bo.EmployeeBO;
import com.cebbank.yyi.springbootapp.tables.CreateTablesBO;
import com.cebbank.yyi.springbootapp.tables.ImportDataBO;
import org.apache.ibatis.annotations.Mapper;

import java.util.HashMap;
import java.util.List;


@Mapper
public interface ExcelInfoMapper {

    void createTable(List<CreateTablesBO> list);

    int insertExcelValues(ImportDataBO list);

    List<HashMap<String, Object>> executeSql(String sql);

    List<HashMap<String, String>> getTableFiled(String tableName);

    List<HashMap<String, Object>> getTableData(List<String> columns, String tableName);

    List<String> getAllTables();

    void insertDepart(EmployeeBO employeeBo);



}
